SUPPORT / SAMPLES & SAS NOTES
Problem Note 59899: A performance degradation might occur in SAS® Merchandise Allocation when you use the Special Calc 18 method option
 |  |  |  |
In SAS® Merchandise Allocation, the performance of seeding a worksheet degrades significantly when you specify the Special Calc 18 method option. The following error message might be generated in the log file:
>>> Info [DTM(Fri Jan 13 10:33:06 2017 : 3) TID(29524) SRC(CSeedAllocation::GetNumOfNonZeroPeriodsForTimeRange) MSG(Special Calc 18: select distinct time_id FROM MAXDATA.MINVENTORY where time_id in( 200801,200802,200803,200804,200805,200806,200807,200808,200809,200810,200811,200 812,200813,200814,200815,200816,200817,200818,200819,200820,200821,200822,200823 ,200824,200825,200826,200827,200828,200829,200830,200831,200832,200833,200834,20 0835,200836,200837,200838,200839,200840,200841,200842,200843,200844,200845,20084 6,200847,200848,200849,200850,200851,200852 ) and location_id = 595 and merch_id = 1 and merch_level = 1 and time_level = 51 and location_level = 4 and OH_ITEMS > 0.0)] >>> Info [DTM(Fri Jan 13 10:33:06 2017 : 3) TID(29524) SRC(CSeedAllocation::HandleSpecialCalc) MSG(Special Calc 18: Count: 0.000000: Target KPI: 72977)]
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Allocation | Microsoft® Windows® for x64 | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 | ||
| Linux for x64 | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 | ||